package com.example.administrator.myapplication.Util;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

/**
 * Created by Administrator on 2020/12/10.
 */

public class DB {
    //用户登录时 根据用户输入的用户姓名学号，查询数据库 是否存在数据
    //select* from account where username =" "and student_id = ""

   private Context context;
    public DB(Context context){
        this.context = context;
    }

    public boolean loginSelect(String username,String student_id){
        MyHelper myHelper = new MyHelper(context);
        SQLiteDatabase db = myHelper.getReadableDatabase();
        Cursor cursor = db.rawQuery("select* from account where username =? and student_id =?",new String[]{username,student_id});
        if(cursor.getCount()!=0){
            return true;
        }else {
            return false;
        }
    }
    //注册
    //insert into account(username,student_id)  values(?,?);
    public boolean signInInsert(String username,String student_id){
        MyHelper myHelper = new MyHelper(context);
        SQLiteDatabase db = myHelper.getWritableDatabase();
        db.execSQL("insert into account(username,student_id)  values(?,?);",new Object[]{username,student_id});
        return true;
    }
}
